SELECT col0 , LAG(col0,1) OVER ( PARTITION BY col2 ORDER BY col0 ) LAG_col0 FROM "fewRowsAllData.parquet"